﻿CREATE TABLE [dbo].[CatPaciente] (
    [IdPaciente]      INT            NOT NULL,
    [IdLaboratorio]   INT            NOT NULL,
    [IdTitulo]        INT            NOT NULL,
    [Nombre]          NVARCHAR (150) NULL,
    [ApellidoPaterno] NVARCHAR (150) NULL,
    [ApellidoMaterno] NVARCHAR (150) NULL,
    [Edad]            INT            NULL,
    [IdTiempo]        INT            NULL,
    [IdSexo]          INT            NULL,
    [IdEstado]        INT            NULL,
    [IdMunicipio]     INT            NULL,
    [CodigoPostal]    BIGINT         NULL,
    [IdColonia]       INT            NULL,
    [Calle]           NVARCHAR (200) NULL,
    [NumeroExt]       NVARCHAR (20)  NULL,
    [NumeroInt]       NVARCHAR (20)  NULL,
    [Telefono]        NVARCHAR (20)  NULL,
    [IdProcedencia]   INT            NULL,
    [FechaMod]        DATETIME       NULL,
    [IpMod]           VARCHAR (15)   NULL,
    [IdUsuarioMod]    INT            NULL,
    [IdSucursal]      INT            NOT NULL,
    [fur]             DATE           NULL,
    [IdDoctor]        INT            NULL,
    [EsActivo]        TINYINT        NULL
);





